<html><head><title>ASH Report - From 22-May-12 00:00:00 To 23-May-12 00:00:00</title>
<style type="text/css">
body.awr {font:bold 10pt Arial,Helvetica,Geneva,sans-serif;color:black; background:White;}
pre.awr  {font:8pt Courier;color:black; background:White;}
h1.awr   {font:bold 20pt Arial,Helvetica,Geneva,sans-serif;color:#336699;background-color:White;border-bottom:1px solid #cccc99;margin-top:0pt; margin-bottom:0pt;padding:0px 0px 0px 0px;}
h2.awr   {font:bold 18pt Arial,Helvetica,Geneva,sans-serif;color:#336699;background-color:White;margin-top:4pt; margin-bottom:0pt;}
h3.awr {font:bold 16pt Arial,Helvetica,Geneva,sans-serif;color:#336699;background-color:White;margin-top:4pt; margin-bottom:0pt;}
li.awr {font: 8pt Arial,Helvetica,Geneva,sans-serif; color:black; background:White;}
th.awrnobg {font:bold 8pt Arial,Helvetica,Geneva,sans-serif; color:black; background:White;padding-left:4px; padding-right:4px;padding-bottom:2px}
th.awrbg {font:bold 8pt Arial,Helvetica,Geneva,sans-serif; color:White; background:#0066CC;padding-left:4px; padding-right:4px;padding-bottom:2px}
td.awrnc {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;}
td.awrc    {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;}
td.awrnclb {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-left: thin solid black;}
td.awrncbb {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-left: thin solid black;border-right: thin solid black;}
td.awrncrb {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-right: thin solid black;}
td.awrcrb    {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-right: thin solid black;}
td.awrclb    {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-left: thin solid black;}
td.awrcbb    {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-left: thin solid black;border-right: thin solid black;}
a.awr {font:bold 8pt Arial,Helvetica,sans-serif;color:#663300; vertical-align:top;margin-top:0pt; margin-bottom:0pt;}
td.awrnct {font:8pt Arial,Helvetica,Geneva,sans-serif;border-top: thin solid black;color:black;background:White;vertical-align:top;}
td.awrct   {font:8pt Arial,Helvetica,Geneva,sans-serif;border-top: thin solid black;color:black;background:#FFFFCC; vertical-align:top;}
td.awrnclbt  {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-top: thin solid black;border-left: thin solid black;}
td.awrncbbt  {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-left: thin solid black;border-right: thin solid black;border-top: thin solid black;}
td.awrncrbt {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-top: thin solid black;border-right: thin solid black;}
td.awrcrbt     {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-top: thin solid black;border-right: thin solid black;}
td.awrclbt     {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-top: thin solid black;border-left: thin solid black;}
td.awrcbbt   {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-top: thin solid black;border-left: thin solid black;border-right: thin solid black;}
table.tdiff {  border_collapse: collapse; }
</style></head><body class="awr">
<h1 class="awr">
ASH Report For E2SNDB/E2SNDB

</h1>
<p />
<table border="1" width="500">
<tr><th class="awrbg">DB Name</th><th class="awrbg">DB Id</th><th class="awrbg">Instance</th><th class="awrbg">Inst num</th><th class="awrbg">Release</th><th class="awrbg">RAC</th><th class="awrbg">Host</th></tr>
<tr><td class='awrnc'>E2SNDB</td><td align="right" class='awrnc'>3356242802</td><td class='awrnc'>E2SNDB</td><td align="right" class='awrnc'>1</td><td class='awrnc'>11.2.0.2.0</td><td class='awrnc'>NO</td><td class='awrnc'>e2sn.localdomain</td></tr>
</table>
<p />
<p />
<table border="1" width="500">
<tr><th class="awrbg">CPUs</th><th class="awrbg">SGA Size</th><th class="awrbg">Buffer Cache</th><th class="awrbg">Shared Pool</th><th class="awrbg">ASH Buffer Size</th></tr>
<tr><td align="right" class='awrnc'>8</td><td align="right" class='awrnc'>499M (100%)</td><td align="right" class='awrnc'>260M (52.1%)</td><td align="right" class='awrnc'>216M (43.3%)</td><td align="right" class='awrnc'>10.0M (2.0%)</td></tr>
</table>
<p />
<p />
<table border="1" width="500">
<tr><th class="awrnobg"></th><th class="awrbg">Sample Time</th><th class="awrbg">Data Source</th></tr>
<tr><td class='awrc'>Analysis Begin Time:</td><td align="right" class='awrc'>22-May-12 00:00:00</td><td align="center" class='awrc'>V$ACTIVE_SESSION_HISTORY</td></tr>
<tr><td class='awrnc'>Analysis End Time:</td><td align="right" class='awrnc'>23-May-12 00:00:00</td><td align="center" class='awrnc'>V$ACTIVE_SESSION_HISTORY</td></tr>
<tr><td class='awrc'>Elapsed Time:</td><td align="right" class='awrc'>   1,440.0 (mins) </td><td align="center" class='awrc'>&#160;</td></tr>
<tr><td class='awrnc'>Sample Count:</td><td align="right" class='awrnc'>     19,678</td><td class='awrnc'>&#160;</td></tr>
<tr><td class='awrc'>Average Active Sessions:</td><td align="right" class='awrc'>       0.23</td><td class='awrc'>&#160;</td></tr>
<tr><td class='awrnc'>Avg. Active Session per CPU:</td><td align="right" class='awrnc'>       0.03</td><td class='awrnc'>&#160;</td></tr>
<tr><td class='awrnc'>Report Target:</td><td align="right" class='awrnc'>None specified</td><td align="center" class='awrnc'>&#160;</td></tr>
</table>
<p />
<a class="awr" name="top"></a>
<h2 class="awr">
ASH Report
</h2>
<ul>
<li class="awr"><a class="awr" href="#101">Top Events</a></li>
<li class="awr"><a class="awr" href="#102">Load Profile</a></li>
<li class="awr"><a class="awr" href="#104">Top SQL</a></li>
<li class="awr"><a class="awr" href="#10380">Top PL/SQL</a></li>
<li class="awr"><a class="awr" href="#10390">Top Java</a></li>
<li class="awr"><a class="awr" href="#10391">Top Call Types</a></li>
<li class="awr"><a class="awr" href="#105">Top Sessions</a></li>
<li class="awr"><a class="awr" href="#106">Top Objects/Files/Latches</a></li>
<li class="awr"><a class="awr" href="#10200">Activity Over Time</a></li>
</ul>
<br /><a class="awr" href="#top">Back to Top</a><hr /><p />
<a class="awr" name="101"></a>
<h2 class="awr">
Top Events
</h2>
<ul>
<li class="awr"><a class="awr" href="#10010">Top User Events</a></li>
<li class="awr"><a class="awr" href="#10020">Top Background Events</a></li>
<li class="awr"><a class="awr" href="#10030">Top Event P1/P2/P3 Values</a></li>
</ul>
<a class="awr" href="#top">Back to Top</a><p />
<a class="awr" name="10010"></a>
<h3 class="awr">Top User Events</h3>
<ul>
</ul>
<table border="1"><tr><th class="awrbg">Event</th><th class="awrbg">Event Class</th><th class="awrbg">% Event</th><th class="awrbg">Avg Active Sessions</th></tr>
<tr><td class='awrc'>CPU + Wait for CPU</td><td class='awrc'>CPU</td><td align="right" class='awrc'>60.90</td><td align="right" class='awrc'>0.14</td></tr>
<tr><td class='awrnc'>db file sequential read</td><td class='awrnc'>User I/O</td><td align="right" class='awrnc'>9.59</td><td align="right" class='awrnc'>0.02</td></tr>
</table><p />
<a class="awr" href="#101">Back to Top Events</a>
<br /><a class="awr" href="#top">Back to Top</a><p />
<a class="awr" name="10020"></a>
<h3 class="awr">Top Background Events</h3>
<ul>
</ul>
<table border="1"><tr><th class="awrbg">Event</th><th class="awrbg">Event Class</th><th class="awrbg">% Activity</th><th class="awrbg">Avg Active Sessions</th></tr>
<tr><td class='awrc'>CPU + Wait for CPU</td><td class='awrc'>CPU</td><td align="right" class='awrc'>27.63</td><td align="right" class='awrc'>0.06</td></tr>
</table><p />
<a class="awr" href="#101">Back to Top Events</a>
<br /><a class="awr" href="#top">Back to Top</a><p />
<a class="awr" name="10030"></a>
<h3 class="awr">Top Event P1/P2/P3 Values</h3>
<ul>
</ul>
<table border="1"><tr><th class="awrbg">Event</th><th class="awrbg">% Event</th><th class="awrbg">P1 Value, P2 Value, P3 Value</th><th class="awrbg">% Activity</th><th class="awrbg">Parameter 1</th><th class="awrbg">Parameter 2</th><th class="awrbg">Parameter 3</th></tr>
<tr><td class='awrc'>db file sequential read</td><td align="right" class='awrc'>9.64</td><td align="right" class='awrc'>&quot;9&quot;,&quot;450786&quot;,&quot;1&quot;</td><td align="right" class='awrc'>0.02</td>
<td class='awrc'>file#</td><td class='awrc'>block#</td><td class='awrc'>blocks</td></tr>
</table><p />
<a class="awr" href="#101">Back to Top Events</a>
<br /><a class="awr" href="#top">Back to Top</a><p />
<p />
<a class="awr" name="102"></a>
<h2 class="awr">
Load Profile
</h2>
<ul>
<li class="awr"><a class="awr" href="#10100">Top Service/Module</a></li>
<li class="awr"><a class="awr" href="#10110">Top Client IDs</a></li>
<li class="awr"><a class="awr" href="#10120">Top SQL Command Types</a></li>
<li class="awr"><a class="awr" href="#10130">Top Phases of Execution</a></li>
</ul>
<a class="awr" href="#top">Back to Top</a><p />
<a class="awr" name="10100"></a>
<h3 class="awr">Top Service/Module</h3>
<ul>
</ul>
<table border="1"><tr><th class="awrbg">Service</th><th class="awrbg">Module</th><th class="awrbg">% Activity</th><th class="awrbg">Action</th><th class="awrbg">% Action</th></tr>
<tr><td class='awrc'>E2SNDB</td><td class='awrc'>New Order</td><td align="right" class='awrc'>41.38</td><td class='awrc'>UNNAMED</td><td align="right" class='awrc'>24.54</td></tr>
<tr><td class='awrnc'>&#160;</td><td class='awrnc'>&#160;</td><td align="right" class='awrnc'>&#160;</td><td class='awrnc'>getProductQuantity</td><td align="right" class='awrnc'>6.97</td></tr>
<tr><td class='awrc'>&#160;</td><td class='awrc'>&#160;</td><td align="right" class='awrc'>&#160;</td><td class='awrc'>getProductDetailsByCategory</td><td align="right" class='awrc'>5.85</td></tr>
<tr><td class='awrnc'>SYS$BACKGROUND</td><td class='awrnc'>UNNAMED</td><td align="right" class='awrnc'>28.47</td><td class='awrnc'>UNNAMED</td><td align="right" class='awrnc'>28.47</td></tr>
<tr><td class='awrc'>E2SNDB</td><td class='awrc'>Browse Products</td><td align="right" class='awrc'>18.18</td><td class='awrc'>getProductDetails</td><td align="right" class='awrc'>7.27</td></tr>
<tr><td class='awrnc'>&#160;</td><td class='awrnc'>&#160;</td><td align="right" class='awrnc'>&#160;</td><td class='awrnc'>UNNAMED</td><td align="right" class='awrnc'>6.11</td></tr>
<tr><td class='awrc'>&#160;</td><td class='awrc'>&#160;</td><td align="right" class='awrc'>&#160;</td><td class='awrc'>logon</td><td align="right" class='awrc'>3.58</td></tr>
<tr><td class='awrnc'>&#160;</td><td class='awrnc'>UNNAMED</td><td align="right" class='awrnc'>3.66</td><td class='awrnc'>UNNAMED</td><td align="right" class='awrnc'>3.66</td></tr>
<tr><td class='awrc'>&#160;</td><td class='awrc'>New Customer</td><td align="right" class='awrc'>1.95</td><td class='awrc'>logon</td><td align="right" class='awrc'>1.23</td></tr>
</table><p />
<a class="awr" href="#102">Back to Load Profile</a>
<br /><a class="awr" href="#top">Back to Top</a><p />
<a class="awr" name="10110"></a>
<h3 class="awr">Top Client IDs</h3>

<p />
                  No data exists for this section of the report.
<p />
<a class="awr" href="#102">Back to Load Profile</a>
<br /><a class="awr" href="#top">Back to Top</a><p />
<a class="awr" name="10120"></a>
<h3 class="awr">Top SQL Command Types</h3>
<ul>
<li class="awr"> 'Distinct SQLIDs' is the count of the distinct number of SQLIDs       with the given SQL Command Type found over all the ASH samples       in the analysis period</li>
</ul>
<table border="1"><tr><th class="awrbg">SQL Command Type</th><th class="awrbg">Distinct SQLIDs</th><th class="awrbg">% Activity</th><th class="awrbg">Avg Active Sessions</th></tr>
<tr><td class='awrc'>PL/SQL EXECUTE</td><td align="right" class='awrc'>16</td><td align="right" class='awrc'>40.69</td><td align="right" class='awrc'>0.09</td></tr>
<tr><td class='awrnc'>SELECT</td><td align="right" class='awrnc'>175</td><td align="right" class='awrnc'>17.27</td><td align="right" class='awrnc'>0.04</td></tr>
<tr><td class='awrc'>INSERT</td><td align="right" class='awrc'>17</td><td align="right" class='awrc'>7.86</td><td align="right" class='awrc'>0.02</td></tr>
<tr><td class='awrnc'>UPDATE</td><td align="right" class='awrnc'>13</td><td align="right" class='awrnc'>3.36</td><td align="right" class='awrnc'>0.01</td></tr>
</table><p />
<a class="awr" href="#102">Back to Load Profile</a>
<br /><a class="awr" href="#top">Back to Top</a><p />
<a class="awr" name="10130"></a>
<h3 class="awr">Top Phases of Execution</h3>
<ul>
</ul>
<table border="1"><tr><th class="awrbg">Phase of Execution</th><th class="awrbg">% Activity</th><th class="awrbg">Avg Active Sessions</th></tr>
<tr><td class='awrc'>SQL Execution</td><td align="right" class='awrc'>69.71</td><td align="right" class='awrc'>0.16</td></tr>
<tr><td class='awrnc'>PLSQL Execution</td><td align="right" class='awrnc'>37.05</td><td align="right" class='awrnc'>0.08</td></tr>
</table><p />
<a class="awr" href="#102">Back to Load Profile</a>
<br /><a class="awr" href="#top">Back to Top</a><p />
<p />
<a class="awr" name="104"></a>
<h2 class="awr">
Top SQL
</h2>
<ul>
<li class="awr"><a class="awr" href="#10300">Top SQL with Top Events</a></li>
<li class="awr"><a class="awr" href="#10305">Top SQL with Top Row Sources</a></li>
<li class="awr"><a class="awr" href="#10370">Top SQL using literals</a></li>
<li class="awr"><a class="awr" href="#10375">Top Parsing Module/Action</a></li>
<li class="awr"><a class="awr" href="#99997">Complete List of SQL Text</a></li>
</ul>
<a class="awr" href="#top">Back to Top</a><p />
<a class="awr" name="10300"></a>
<h3 class="awr">Top SQL with Top Events</h3>
<ul>
</ul>
<table border="1"><tr><th class="awrbg">SQL ID</th><th class="awrbg">Planhash</th><th class="awrbg">Sampled # of Executions</th><th class="awrbg">% Activity</th><th class="awrbg">Event</th><th class="awrbg">% Event</th><th class="awrbg">Top Row Source</th><th class="awrbg">% RwSrc</th><th class="awrbg">SQL Text</th></tr>
<tr><td align="right" class='awrc'><a class="awr" href="#0w2qpuc6u2zsp">0w2qpuc6u2zsp</a></td><td align="right" class='awrc'>&#160;</td><td align="right" class='awrc'>4404</td><td align="right" class='awrc'>22.74</td>
<td class='awrc'>CPU + Wait for CPU</td><td align="right" class='awrc'>22.71</td><td class='awrc'>** Row Source Not Available **</td><td align="right" class='awrc'>22.71</td>
<td class='awrc'>BEGIN :1 := orderentry.neworde...</td></tr>
<tr><td align="right" class='awrnc'><a class="awr" href="#147a57cxq3w5y">147a57cxq3w5y</a></td><td align="right" class='awrnc'>&#160;</td><td align="right" class='awrnc'>3148</td><td align="right" class='awrnc'>16.05</td>
<td class='awrnc'>CPU + Wait for CPU</td><td align="right" class='awrnc'>16.05</td><td class='awrnc'>** Row Source Not Available **</td><td align="right" class='awrnc'>16.05</td>
<td class='awrnc'>BEGIN :1 := orderentry.browsep...</td></tr>
<tr><td align="right" class='awrc'><a class="awr" href="#c749bc43qqfz3">c749bc43qqfz3</a></td><td align="right" class='awrc'>1388734953</td><td align="right" class='awrc'>185</td><td align="right" class='awrc'>4.18</td>
<td class='awrc'>CPU + Wait for CPU</td><td align="right" class='awrc'>4.18</td><td class='awrc'>SELECT STATEMENT</td><td align="right" class='awrc'>4.16</td>
<td class='awrc'>SELECT SYSDATE FROM DUAL</td></tr>
<tr><td align="right" class='awrnc'><a class="awr" href="#8z3542ffmp562">8z3542ffmp562</a></td><td align="right" class='awrnc'>1655552467</td><td align="right" class='awrnc'>190</td><td align="right" class='awrnc'>3.39</td>
<td class='awrnc'>CPU + Wait for CPU</td><td align="right" class='awrnc'>3.18</td><td class='awrnc'>SELECT STATEMENT</td><td align="right" class='awrnc'>2.84</td>
<td class='awrnc'>SELECT QUANTITY_ON_HAND FROM P...</td></tr>
<tr><td align="right" class='awrc'><a class="awr" href="#bymb3ujkr3ubk">bymb3ujkr3ubk</a></td><td align="right" class='awrc'>494735477</td><td align="right" class='awrc'>380</td><td align="right" class='awrc'>3.39</td>
<td class='awrc'>CPU + Wait for CPU</td><td align="right" class='awrc'>1.82</td><td class='awrc'>INSERT STATEMENT</td><td align="right" class='awrc'>1.65</td>
<td class='awrc'>INSERT INTO ORDERS(ORDER_ID, O...</td></tr>
<tr><td align="right" class='awrnc'>&#160;</td><td align="right" class='awrnc'>&#160;</td><td align="right" class='awrnc'>&#160;</td><td align="right" class='awrnc'>&#160;</td>
<td class='awrnc'>db file sequential read</td><td align="right" class='awrnc'>1.57</td><td class='awrnc'>LOAD TABLE CONVENTIONAL</td><td align="right" class='awrnc'>1.57</td>
<td class='awrnc'></td></tr>
</table><p />
<a class="awr" href="#104">Back to Top SQL</a>
<br /><a class="awr" href="#top">Back to Top</a><p />
<a class="awr" name="10305"></a>
<h3 class="awr">Top SQL with Top Row Sources</h3>
<ul>
</ul>
<table border="1"><tr><th class="awrbg">SQL ID</th><th class="awrbg">PlanHash</th><th class="awrbg">Sampled # of Executions</th><th class="awrbg">% Activity</th><th class="awrbg">Row Source</th><th class="awrbg">% RwSrc</th><th class="awrbg">Top Event</th><th class="awrbg">% Event</th><th class="awrbg">SQL Text</th></tr>
<tr><td align="right" class='awrc'><a class="awr" href="#0w2qpuc6u2zsp">0w2qpuc6u2zsp</a></td><td align="right" class='awrc'>&#160;</td><td align="right" class='awrc'>4404</td><td align="right" class='awrc'>22.74</td>
<td class='awrc'>** Row Source Not Available **</td><td align="right" class='awrc'>22.74</td><td class='awrc'>CPU + Wait for CPU</td><td align="right" class='awrc'>22.71</td>
<td class='awrc'>BEGIN :1 := orderentry.neworde...</td></tr>
<tr><td align="right" class='awrnc'><a class="awr" href="#147a57cxq3w5y">147a57cxq3w5y</a></td><td align="right" class='awrnc'>&#160;</td><td align="right" class='awrnc'>3148</td><td align="right" class='awrnc'>16.05</td>
<td class='awrnc'>** Row Source Not Available **</td><td align="right" class='awrnc'>16.05</td><td class='awrnc'>CPU + Wait for CPU</td><td align="right" class='awrnc'>16.05</td>
<td class='awrnc'>BEGIN :1 := orderentry.browsep...</td></tr>
<tr><td align="right" class='awrc'><a class="awr" href="#c749bc43qqfz3">c749bc43qqfz3</a></td><td align="right" class='awrc'>1388734953</td><td align="right" class='awrc'>185</td><td align="right" class='awrc'>4.18</td>
<td class='awrc'>SELECT STATEMENT</td><td align="right" class='awrc'>4.16</td><td class='awrc'>CPU + Wait for CPU</td><td align="right" class='awrc'>4.16</td>
<td class='awrc'>SELECT SYSDATE FROM DUAL</td></tr>
<tr><td align="right" class='awrnc'><a class="awr" href="#8z3542ffmp562">8z3542ffmp562</a></td><td align="right" class='awrnc'>1655552467</td><td align="right" class='awrnc'>190</td><td align="right" class='awrnc'>3.39</td>
<td class='awrnc'>SELECT STATEMENT</td><td align="right" class='awrnc'>2.84</td><td class='awrnc'>CPU + Wait for CPU</td><td align="right" class='awrnc'>2.84</td>
<td class='awrnc'>SELECT QUANTITY_ON_HAND FROM P...</td></tr>
<tr><td align="right" class='awrc'><a class="awr" href="#bymb3ujkr3ubk">bymb3ujkr3ubk</a></td><td align="right" class='awrc'>494735477</td><td align="right" class='awrc'>380</td><td align="right" class='awrc'>3.39</td>
<td class='awrc'>LOAD TABLE CONVENTIONAL</td><td align="right" class='awrc'>1.72</td><td class='awrc'>db file sequential read</td><td align="right" class='awrc'>1.57</td>
<td class='awrc'>INSERT INTO ORDERS(ORDER_ID, O...</td></tr>
<tr><td align="right" class='awrnc'>&#160;</td><td align="right" class='awrnc'>&#160;</td><td align="right" class='awrnc'>&#160;</td><td align="right" class='awrnc'>&#160;</td>
<td class='awrnc'>INSERT STATEMENT</td><td align="right" class='awrnc'>1.65</td><td class='awrnc'>CPU + Wait for CPU</td><td align="right" class='awrnc'>1.65</td>
<td class='awrnc'></td></tr>
</table><p />
<a class="awr" href="#104">Back to Top SQL</a>
<br /><a class="awr" href="#top">Back to Top</a><p />
<a class="awr" name="10370"></a>
<h3 class="awr">Top SQL using literals</h3>

<p />
                  No data exists for this section of the report.
<p />
<a class="awr" href="#104">Back to Top SQL</a>
<br /><a class="awr" href="#top">Back to Top</a><p />
<a class="awr" name="10375"></a>
<h3 class="awr">Top Parsing Module/Action</h3>

<p />
                  No data exists for this section of the report.
<p />
<a class="awr" href="#104">Back to Top SQL</a>
<br /><a class="awr" href="#top">Back to Top</a><p />
<a class="awr" name="99997"></a>
<p />
<h3 class="awr">Complete List of SQL Text</h3><p />
<table border="1">
<tr><th class="awrbg">SQL Id</th><th class="awrbg">SQL Text</th></tr>
<tr><td class='awrc'><a class="awr" name="0w2qpuc6u2zsp"></a>0w2qpuc6u2zsp</td><td class='awrc'>BEGIN :1 := orderentry.neworder(:2 , :3 , :4 ); END;</td></tr>
<tr><td class='awrnc'><a class="awr" name="147a57cxq3w5y"></a>147a57cxq3w5y</td><td class='awrnc'>BEGIN :1 := orderentry.browseproducts(:2 , :3 , :4 ); END;</td></tr>
<tr><td class='awrc'><a class="awr" name="8z3542ffmp562"></a>8z3542ffmp562</td><td class='awrc'>SELECT QUANTITY_ON_HAND FROM PRODUCT_INFORMATION P,  INVENTORIES I WHERE I.PRODUCT_ID = :B2 AND I.PRODUCT_ID = P.PRODUCT_ID AND I.WAREHOUSE_ID = :B1 </td></tr>
<tr><td class='awrnc'><a class="awr" name="bymb3ujkr3ubk"></a>bymb3ujkr3ubk</td><td class='awrnc'>INSERT INTO ORDERS(ORDER_ID,  ORDER_DATE,  CUSTOMER_ID,  WAREHOUSE_ID) VALUES (ORDERS_SEQ.NEXTVAL + :B3 ,  SYSTIMESTAMP ,  :B2 ,  :B1 ) RETURNING ORDER_ID INTO :O0 </td></tr>
<tr><td class='awrc'><a class="awr" name="c749bc43qqfz3"></a>c749bc43qqfz3</td><td class='awrc'>SELECT SYSDATE FROM DUAL</td></tr>
</table>
<p />
<a class="awr" href="#104">Back to Top SQL</a>
<br /><a class="awr" href="#top">Back to Top</a><p />
<p />
<a class="awr" name="10380"></a>
<h3 class="awr">Top PL/SQL Procedures</h3>
<ul>
<li class="awr"> 'PL/SQL entry subprogram' represents the application's top-level        entry-point(procedure, function, trigger, package initialization       or RPC call) into PL/SQL. </li>
<li class="awr"> 'PL/SQL current subprogram' is the pl/sql subprogram being executed        at the point of sampling . If the value is 'SQL', it represents        the percentage of time spent executing SQL for the particular        plsql entry subprogram</li>
</ul>
<table border="1"><tr><th class="awrbg">PLSQL Entry Subprogram</th><th class="awrbg">% Activity</th><th class="awrbg">PLSQL Current Subprogram</th><th class="awrbg">% Current</th></tr>
<tr><td class='awrc'>SOE.ORDERENTRY.NEWORDER</td><td align="right" class='awrc'>41.39</td>
<td class='awrc'>SQL</td><td align="right" class='awrc'>20.63</td></tr>
<tr><td class='awrnc'>&#160;</td><td align="right" class='awrnc'>&#160;</td>
<td class='awrnc'>SOE.ORDERENTRY.NEWORDER</td><td align="right" class='awrnc'>11.98</td></tr>
<tr><td class='awrc'>&#160;</td><td align="right" class='awrc'>&#160;</td>
<td class='awrc'>SYS.DBMS_APPLICATION_INFO.SET_ACTION</td><td align="right" class='awrc'>4.63</td></tr>
<tr><td class='awrnc'>SOE.ORDERENTRY.BROWSEPRODUCTS</td><td align="right" class='awrnc'>20.56</td>
<td class='awrnc'>SOE.ORDERENTRY.BROWSEPRODUCTS</td><td align="right" class='awrnc'>9.22</td></tr>
<tr><td class='awrc'>&#160;</td><td align="right" class='awrc'>&#160;</td>
<td class='awrc'>SQL</td><td align="right" class='awrc'>6.13</td></tr>
<tr><td class='awrnc'>&#160;</td><td align="right" class='awrnc'>&#160;</td>
<td class='awrnc'>SYS.DBMS_APPLICATION_INFO.SET_ACTION</td><td align="right" class='awrnc'>3.30</td></tr>
<tr><td class='awrc'>SOE.ORDERENTRY.NEWCUSTOMER</td><td align="right" class='awrc'>1.95</td>
<td class='awrc'>SQL</td><td align="right" class='awrc'>1.42</td></tr>
<tr><td class='awrnc'>SOE.ORDERENTRY.BROWSEANDUPDATEORDERS</td><td align="right" class='awrnc'>1.68</td>
<td class='awrnc'>SQL</td><td align="right" class='awrnc'>1.04</td></tr>
</table><p />
<br /><a class="awr" href="#top">Back to Top</a><p />
<p />
<a class="awr" name="10390"></a>
<h3 class="awr">Top Java Workload</h3>

<p />
                  No data exists for this section of the report.
<p />
<br /><a class="awr" href="#top">Back to Top</a><p />
<p />
<a class="awr" name="10391"></a>
<h3 class="awr">Top Call Types</h3>
<ul>
</ul>
<table border="1"><tr><th class="awrbg">Call Type</th><th class="awrbg">Count</th><th class="awrbg">% Activity</th><th class="awrbg">Avg Active Sessions</th></tr>
<tr><td class='awrc'>V8 Bundled Exec</td><td align="right" class='awrc'>13,643</td><td align="right" class='awrc'>69.33</td><td align="right" class='awrc'>0.16</td></tr>
</table><p />
<br /><a class="awr" href="#top">Back to Top</a><p />
<p />
<a class="awr" name="105"></a>
<h2 class="awr">
Top Sessions
</h2>
<ul>
<li class="awr"><a class="awr" href="#10310">Top Sessions</a></li>
<li class="awr"><a class="awr" href="#10320">Top Blocking Sessions</a></li>
<li class="awr"><a class="awr" href="#10330">Top Sessions running PQs</a></li>
</ul>
<a class="awr" href="#top">Back to Top</a><p />
<a class="awr" name="10310"></a>
<h3 class="awr">Top Sessions</h3>
<ul>
<li class="awr"> '# Samples Active' shows the number of ASH samples in which the session        was found waiting for that particular event. The percentage shown       in this column is calculated with respect to wall clock time       and not total database activity. </li>
<li class="awr"> 'XIDs' shows the number of distinct transaction IDs sampled in ASH        when the session was waiting for that particular event </li>
<li class="awr"> For sessions running Parallel Queries, this section will NOT aggregate        the PQ slave activity into the session issuing the PQ. Refer to        the 'Top Sessions running PQs' section for such statistics.</li>
</ul>
<table border="1"><tr><th class="awrbg">Sid, Serial#</th><th class="awrbg">% Activity</th><th class="awrbg">Event</th><th class="awrbg">% Event</th><th class="awrbg">User</th><th class="awrbg">Program</th><th class="awrbg"># Samples Active</th><th class="awrbg">XIDs</th></tr>
<tr><td align="right" class='awrc'>97,    1</td><td align="right" class='awrc'>21.69</td><td class='awrc'>CPU + Wait for CPU</td><td align="right" class='awrc'>21.69</td>
<td class='awrc'>SYS</td><td class='awrc'>oracle@e2sn.localdomain (PSP0)</td><td align="right" class='awrc'>4,269/86K [  5%]</td><td align="right" class='awrc'>0</td></tr>
<tr><td align="right" class='awrnc'>67,   17</td><td align="right" class='awrnc'>7.11</td><td class='awrnc'>CPU + Wait for CPU</td><td align="right" class='awrnc'>6.14</td>
<td class='awrnc'>SOE</td><td class='awrnc'>JDBC Thin Client</td><td align="right" class='awrnc'>1,208/86K [  1%]</td><td align="right" class='awrnc'>324</td></tr>
<tr><td align="right" class='awrc'>136,10009</td><td align="right" class='awrc'>6.88</td><td class='awrc'>CPU + Wait for CPU</td><td align="right" class='awrc'>5.84</td>
<td class='awrc'>SOE</td><td class='awrc'>JDBC Thin Client</td><td align="right" class='awrc'>1,149/86K [  1%]</td><td align="right" class='awrc'>326</td></tr>
<tr><td align="right" class='awrnc'>&#160;</td><td align="right" class='awrnc'>&#160;</td><td class='awrnc'>db file sequential read</td><td align="right" class='awrnc'>1.03</td>
<td class='awrnc'>&#160;</td><td class='awrnc'>&#160;</td><td align="right" class='awrnc'>203/86K [  0%]</td><td align="right" class='awrnc'>133</td></tr>
<tr><td align="right" class='awrc'>8,59605</td><td align="right" class='awrc'>6.80</td><td class='awrc'>CPU + Wait for CPU</td><td align="right" class='awrc'>5.81</td>
<td class='awrc'>SOE</td><td class='awrc'>JDBC Thin Client</td><td align="right" class='awrc'>1,143/86K [  1%]</td><td align="right" class='awrc'>334</td></tr>
<tr><td align="right" class='awrnc'>161,51547</td><td align="right" class='awrnc'>6.80</td><td class='awrnc'>CPU + Wait for CPU</td><td align="right" class='awrnc'>5.86</td>
<td class='awrnc'>SOE</td><td class='awrnc'>JDBC Thin Client</td><td align="right" class='awrnc'>1,153/86K [  1%]</td><td align="right" class='awrnc'>313</td></tr>
</table><p />
<a class="awr" href="#105">Back to Top Sessions</a>
<br /><a class="awr" href="#top">Back to Top</a><p />
<a class="awr" name="10320"></a>
<h3 class="awr">Top Blocking Sessions</h3>

<p />
                  No data exists for this section of the report.
<p />
<a class="awr" href="#105">Back to Top Sessions</a>
<br /><a class="awr" href="#top">Back to Top</a><p />
<a class="awr" name="10330"></a>
<h3 class="awr">Top Sessions running PQs</h3>

<p />
                  No data exists for this section of the report.
<p />
<a class="awr" href="#105">Back to Top Sessions</a>
<br /><a class="awr" href="#top">Back to Top</a><p />
<p />
<a class="awr" name="106"></a>
<h2 class="awr">
Top Objects/Files/Latches
</h2>
<ul>
<li class="awr"><a class="awr" href="#10340">Top DB Objects</a></li>
<li class="awr"><a class="awr" href="#10350">Top DB Files</a></li>
<li class="awr"><a class="awr" href="#10360">Top Latches</a></li>
</ul>
<a class="awr" href="#top">Back to Top</a><p />
<a class="awr" name="10340"></a>
<h3 class="awr">Top DB Objects</h3>
<ul>
<li class="awr"> With respect to Application, Cluster, User I/O and buffer busy waits only.</li>
</ul>
<table border="1"><tr><th class="awrbg">Object ID</th><th class="awrbg">% Activity</th><th class="awrbg">Event</th><th class="awrbg">% Event</th><th class="awrbg">Object Name (Type)</th><th class="awrbg">Tablespace</th></tr>
<tr><td align="right" class='awrc'>92219</td><td align="right" class='awrc'>2.02</td><td class='awrc'>db file sequential read</td><td align="right" class='awrc'>2.02</td>
<td class='awrc'>SOE.ITEM_PRODUCT_IX (INDEX)</td><td class='awrc'>PPX</td></tr>
<tr><td align="right" class='awrnc'>92211</td><td align="right" class='awrnc'>1.30</td><td class='awrnc'>db file sequential read</td><td align="right" class='awrnc'>1.30</td>
<td class='awrnc'>SOE.ORDER_PK (INDEX)</td><td class='awrnc'>PPX</td></tr>
<tr><td align="right" class='awrc'>92210</td><td align="right" class='awrc'>1.22</td><td class='awrc'>db file sequential read</td><td align="right" class='awrc'>1.21</td>
<td class='awrc'>SOE.ORDER_ITEMS_PK (INDEX)</td><td class='awrc'>PPX</td></tr>
</table><p />
<a class="awr" href="#106">Back to Top Objects/Files/Latches</a>
<br /><a class="awr" href="#top">Back to Top</a><p />
<a class="awr" name="10350"></a>
<h3 class="awr">Top DB Files</h3>
<ul>
<li class="awr"> With respect to Cluster and User I/O events only.</li>
</ul>
<table border="1"><tr><th class="awrbg">File ID</th><th class="awrbg">% Activity</th><th class="awrbg">Event</th><th class="awrbg">% Event</th><th class="awrbg">File Name</th><th class="awrbg">Tablespace</th></tr>
<tr><td align="right" class='awrc'>9</td><td align="right" class='awrc'>9.48</td><td class='awrc'>db file sequential read</td><td align="right" class='awrc'>9.42</td>
<td class='awrc'>/u01/oradata/E2SNDB/ppx01.dbf</td><td class='awrc'>PPX</td></tr>
</table><p />
<a class="awr" href="#106">Back to Top Objects/Files/Latches</a>
<br /><a class="awr" href="#top">Back to Top</a><p />
<a class="awr" name="10360"></a>
<h3 class="awr">Top Latches</h3>

<p />
                  No data exists for this section of the report.
<p />
<a class="awr" href="#106">Back to Top Objects/Files/Latches</a>
<br /><a class="awr" href="#top">Back to Top</a><p />
<p />
<a class="awr" name="10200"></a>
<h3 class="awr">Activity Over Time</h3>
<ul>
<li class="awr"> Analysis period is divided into smaller time slots </li>
<li class="awr"> Top 3 events are reported in each of those slots </li>
<li class="awr"> 'Slot Count' shows the number of ASH samples in that slot </li>
<li class="awr"> 'Event Count' shows the number of ASH samples waiting for    that event in that slot </li>
<li class="awr"> '% Event' is 'Event Count' over all ASH samples in the analysis period</li>
</ul>
<table border="1"><tr><th class="awrbg">Slot Time (Duration)</th><th class="awrbg">Slot Count</th><th class="awrbg">Event</th><th class="awrbg">Event Count</th><th class="awrbg">% Event</th></tr>
<tr><td align="right" class='awrc'>00:00:00 (144.0 min)</td><td align="right" class='awrc'>728</td><td class='awrc'>CPU + Wait for CPU</td><td align="right" class='awrc'>715</td><td align="right" class='awrc'>3.63</td></tr>
<tr><td align="right" class='awrnc'>&#160;</td><td align="right" class='awrnc'>&#160;</td><td class='awrnc'>control file sequential read</td><td align="right" class='awrnc'>8</td><td align="right" class='awrnc'>0.04</td></tr>
<tr><td align="right" class='awrc'>&#160;</td><td align="right" class='awrc'>&#160;</td><td class='awrc'>control file parallel write</td><td align="right" class='awrc'>4</td><td align="right" class='awrc'>0.02</td></tr>
<tr><td align="right" class='awrnc'>02:24:00 (144.0 min)</td><td align="right" class='awrnc'>660</td><td class='awrnc'>CPU + Wait for CPU</td><td align="right" class='awrnc'>645</td><td align="right" class='awrnc'>3.28</td></tr>
<tr><td align="right" class='awrc'>&#160;</td><td align="right" class='awrc'>&#160;</td><td class='awrc'>control file parallel write</td><td align="right" class='awrc'>12</td><td align="right" class='awrc'>0.06</td></tr>
<tr><td align="right" class='awrnc'>&#160;</td><td align="right" class='awrnc'>&#160;</td><td class='awrnc'>control file sequential read</td><td align="right" class='awrnc'>3</td><td align="right" class='awrnc'>0.02</td></tr>
<tr><td align="right" class='awrc'>04:48:00 (144.0 min)</td><td align="right" class='awrc'>842</td><td class='awrc'>CPU + Wait for CPU</td><td align="right" class='awrc'>663</td><td align="right" class='awrc'>3.37</td></tr>
<tr><td align="right" class='awrnc'>&#160;</td><td align="right" class='awrnc'>&#160;</td><td class='awrnc'>db file sequential read</td><td align="right" class='awrnc'>154</td><td align="right" class='awrnc'>0.78</td></tr>
<tr><td align="right" class='awrc'>&#160;</td><td align="right" class='awrc'>&#160;</td><td class='awrc'>db file parallel write</td><td align="right" class='awrc'>9</td><td align="right" class='awrc'>0.05</td></tr>
<tr><td align="right" class='awrnc'>07:12:00 (144.0 min)</td><td align="right" class='awrnc'>3,697</td><td class='awrnc'>CPU + Wait for CPU</td><td align="right" class='awrnc'>3,305</td><td align="right" class='awrnc'>16.80</td></tr>
<tr><td align="right" class='awrc'>&#160;</td><td align="right" class='awrc'>&#160;</td><td class='awrc'>db file sequential read</td><td align="right" class='awrc'>312</td><td align="right" class='awrc'>1.59</td></tr>
<tr><td align="right" class='awrnc'>&#160;</td><td align="right" class='awrnc'>&#160;</td><td class='awrnc'>db file parallel write</td><td align="right" class='awrnc'>45</td><td align="right" class='awrnc'>0.23</td></tr>
<tr><td align="right" class='awrc'>09:36:00 (144.0 min)</td><td align="right" class='awrc'>3,356</td><td class='awrc'>CPU + Wait for CPU</td><td align="right" class='awrc'>3,039</td><td align="right" class='awrc'>15.44</td></tr>
<tr><td align="right" class='awrnc'>&#160;</td><td align="right" class='awrnc'>&#160;</td><td class='awrnc'>db file sequential read</td><td align="right" class='awrnc'>274</td><td align="right" class='awrnc'>1.39</td></tr>
<tr><td align="right" class='awrc'>&#160;</td><td align="right" class='awrc'>&#160;</td><td class='awrc'>db file parallel write</td><td align="right" class='awrc'>22</td><td align="right" class='awrc'>0.11</td></tr>
<tr><td align="right" class='awrnc'>12:00:00 (144.0 min)</td><td align="right" class='awrnc'>3,245</td><td class='awrnc'>CPU + Wait for CPU</td><td align="right" class='awrnc'>2,959</td><td align="right" class='awrnc'>15.04</td></tr>
<tr><td align="right" class='awrc'>&#160;</td><td align="right" class='awrc'>&#160;</td><td class='awrc'>db file sequential read</td><td align="right" class='awrc'>249</td><td align="right" class='awrc'>1.27</td></tr>
<tr><td align="right" class='awrnc'>&#160;</td><td align="right" class='awrnc'>&#160;</td><td class='awrnc'>db file parallel write</td><td align="right" class='awrnc'>17</td><td align="right" class='awrnc'>0.09</td></tr>
<tr><td align="right" class='awrc'>14:24:00 (144.0 min)</td><td align="right" class='awrc'>3,344</td><td class='awrc'>CPU + Wait for CPU</td><td align="right" class='awrc'>3,085</td><td align="right" class='awrc'>15.68</td></tr>
<tr><td align="right" class='awrnc'>&#160;</td><td align="right" class='awrnc'>&#160;</td><td class='awrnc'>db file sequential read</td><td align="right" class='awrnc'>228</td><td align="right" class='awrnc'>1.16</td></tr>
<tr><td align="right" class='awrc'>&#160;</td><td align="right" class='awrc'>&#160;</td><td class='awrc'>db file parallel write</td><td align="right" class='awrc'>20</td><td align="right" class='awrc'>0.10</td></tr>
<tr><td align="right" class='awrnc'>16:48:00 (144.0 min)</td><td align="right" class='awrnc'>2,998</td><td class='awrnc'>CPU + Wait for CPU</td><td align="right" class='awrnc'>2,382</td><td align="right" class='awrnc'>12.10</td></tr>
<tr><td align="right" class='awrc'>&#160;</td><td align="right" class='awrc'>&#160;</td><td class='awrc'>db file sequential read</td><td align="right" class='awrc'>517</td><td align="right" class='awrc'>2.63</td></tr>
<tr><td align="right" class='awrnc'>&#160;</td><td align="right" class='awrnc'>&#160;</td><td class='awrnc'>db file parallel write</td><td align="right" class='awrnc'>35</td><td align="right" class='awrnc'>0.18</td></tr>
<tr><td align="right" class='awrc'>19:12:00 (144.0 min)</td><td align="right" class='awrc'>814</td><td class='awrc'>CPU + Wait for CPU</td><td align="right" class='awrc'>631</td><td align="right" class='awrc'>3.21</td></tr>
<tr><td align="right" class='awrnc'>&#160;</td><td align="right" class='awrnc'>&#160;</td><td class='awrnc'>db file sequential read</td><td align="right" class='awrnc'>165</td><td align="right" class='awrnc'>0.84</td></tr>
<tr><td align="right" class='awrc'>&#160;</td><td align="right" class='awrc'>&#160;</td><td class='awrc'>db file parallel write</td><td align="right" class='awrc'>8</td><td align="right" class='awrc'>0.04</td></tr>
</table><p />
<br /><a class="awr" href="#top">Back to Top</a><p />
<p />
End of Report
</body></html>

448 rows selected.

